SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:If you’re looking for a full-time residence or a second home where everyone can gather, spread out, and truly reconnect, 3 Fairway Drive in the Eastman Community delivers. This 5-bedroom, 5-bath contemporary Cape offers a smart, flexible floor plan designed for long weekends, holidays, and memorable summer stays with family and friends. Two en suite bedrooms on the main level make hosting effortless and ideal for single-level living, while the upper-level bedrooms provide cozy, private retreats for guests, or extended family. At the heart of the home, the centrally located kitchen keeps everyone connected, flowing seamlessly into the dining room, family room, and living room—perfect for shared meals, games, and relaxed evenings together. Outdoor living shines here. The screened porch and expansive deck invite morning coffee with golf-course views, afternoon grilling, evening stargazing, and casual gatherings that stretch late into the night. The finished walk-out lower level adds even more versatility, featuring a bedroom, office, family room, and generous storage for skis, beach gear, and all the essentials of active New England living. Set on a private 0.62-acre lot with an attached two-car garage, this home offers full access to Eastman’s lake, beaches, trails, golf course, and recreation center—within a welcoming, amenity-rich community built for year-round enjoyment. Conveniently located just minutes from Dartmouth Hitchcock Medical Center and Dartmouth College, this is a place where lifestyle, comfort, and connection come together.
Description:Superb location just minutes from Main Street, Hanover and Dartmouth College on desirable Haskins Rd, a quiet dead end street. This 3 bedroom, 2 bath home features a family room with fireplace, dining area and updated kitchen on the main floor with hardwood floors throughout. Upstairs the primary bedroom is situated at the rear of the home with a loft for storage, 2 additional bedrooms, a full bath and a sunny office. Bring your ideas and refresh this cozy contemporary to make it your own while enjoying the peaceful, wooded surroundings. Hiking trails, including the AT, are close by. Conveniently located close to town, schools and short 10 min commute to Dartmouth Health. Showings will begin on Friday BY APPOINTMENT between 3-5 and Saturday BY APPOINTMENT from 11-1.
Description:PRICE IMPROVEMENT: Spacious home located in the Olde Farms community (not an HOA) and an Approx. 25-minute drive to DHMC. The home is nestled on 7.92 private acres located in beautiful Grantham NH. This spacious 4-bedroom, 3.5-bath home offers the perfect blend of privacy, comfort, and convenience. Set well back from the main road, the property provides a peaceful country setting with stunning views and plenty of room to enjoy the outdoors. Inside, you’ll find generous living space throughout, including two oversized unfinished bonus rooms ready for your personal touch — ideal for a home office, gym, guest suite, media room, or additional living space. The large basement offers even more storage or expansion potential. Step outside to relax on the expansive deck or unwind in the hot tub while taking in the scenic surroundings. Additional highlights include a two-car garage, paved driveway, and an on-demand generator for added peace of mind. Despite its tranquil setting, this property offers easy access to Interstate 89, making commuting and travel convenient while still enjoying the beauty and privacy of country living. Approximately 25-minute drive to DHMC and other Upper valley amenities. A rare opportunity to own a private country property in one of Grantham’s most desirable locations.
Description:What a gem situated within the big little city of Lebanon, NH. Built during the Eastlake Architectural movement in 1860 this Victorian home has all the features one expects to see for the time period including ornate floral carvings that adorn the exterior. Tastefully updated by the few owners who have appreciated her history, this home provides ample space for cohabitation of one or more generations of occupants. Off the rear of the home, where you will find ample parking, is a separate entrance that could be used as a home based office complete with kitchenette and bathroom. It can even serve as quarters for an in home assistant to the residents or good friend or family member. From the front or side covered porch you enter the main home and appreciate the history that flows from its rooms. Two options for a first floor bedroom are available for those who desire or need single level living. A three season sunroom on the second floor could function as a game room, exercise space or a space to entertain or hang 10; the possibilities abound. Combine this with ample sized sleeping rooms including an impressive primary suite, the second floor fosters a feeling of home with its comfort and warmth. The basement would make for an impressive home based gym essential for the winter months when we feel somewhat trapped by the weather or perhaps even a daycare as I understand it once was. Walking distance to the Marsh Brothers Deli, Lucky's Coffee House, Village Pizzeria, Salthill Irish pub, Three Tomatoes Italian Restaurant and Lebanon Opera House means the property is near the Lebanon Green famous for its outdoor concerts, farmers markets and festivals. Perhaps you're interested in an investment property vs. a single family dwelling? This home and layout provides many opportunities.
Description:A sportsman's Paradise! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.